package com.sailfish.springbootdemo.dao.db7;

import com.sailfish.springbootdemo.common.DB7TableName;
import com.sailfish.springbootdemo.pojo.db7.TbFlowMain;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TbFlowMainDao {

    @Select("<script> " +
            "select \n" +
            "*" +
            " from " + DB7TableName.TB_FLOW_MAIN +
            " where 1=1" +
            " and flow_type in " +
            "<foreach item='type' index='index' collection='types' open='(' separator=',' close=')'>" +
            "#{type}" +
            "</foreach>" +
            "</script>")
    List<TbFlowMain> getFlowMainList(@Param("types") List<String> types);
}
